Mid

Mid(string, start[, length])

Returns part of a string starting at a specified position within the string.

All

string - required

String from which the characters are to be extracted.

start - required

Starting point within the string – the first character is position 1.

length - optional

Number of characters to be returned.

String containing the extracted characters.

The start parameter specifies a value which is beyond the end of the string.

Character positions within the original string go from left to right, i.e. first character in the string is the left-most character, second is the one to right of this and so on.

If you omit the length parameter all characters from the specified start character to the end of the string will be returned. For example, Mid("Hello World", 4) will return "lo World".

If the length parameter exceeds the length of the string the Method will return the characters from the start position to the end of the string.